<?php

namespace app\admin\controller;

use app\common\controller\Backend;

use app\admin\model\Vuearea;

use think\Db;



/**
 * 
 *
 * @icon fa fa-circle-o
 */
class TrainUser extends Backend
{

    /**
     * TrainUser模型对象
     * @var \app\admin\model\TrainUser
     */
    protected $model = null;

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\admin\model\TrainUser;

    }



    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */


    /**
     * 查看[改造]
     */
    public function index()
    {
        //当前是否为关联查询
        $this->relationSearch = true;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('keyField')) {
                return $this->selectpage();
            }
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();

            $list = $this->model
                    ->with(['train','user'])
                    ->where($where)
                    ->order($sort, $order)
                    ->paginate($limit);

            foreach ($list as $row) {
                $row->visible(['id','sign','createtime']);
                $row->visible(['train']);
				$row->getRelation('train')->visible(['name']);
				$row->visible(['user']);
				$row->getRelation('user')->visible(['username']);
            }
            $data = ["total" => $list->total(),"rows" => $list->items()];
            $result = array('code'=>1,'msg'=>'成功', 'wait'=>'3', 'data'=>$data);

            return json($result);
        }
        return $this->view->fetch();
    }
    /**
         * 添加[改造]
         *
         * @return string
         * @throws \think\Exception
         */
        public function add()
        {
            if (false === $this->request->isPost()) {
                return $this->view->fetch();
            }
            $params = $this->conversion2str(json_decode($this->request->post('data'),true));
            if (empty($params)) {
                $this->error(__('Parameter %s can not be empty', ''));
            }
            $params = $this->preExcludeFields($params);

            if ($this->dataLimit && $this->dataLimitFieldAutoFill) {
                $params[$this->dataLimitField] = $this->auth->id;
            }
            $result = false;
            Db::startTrans();
            try {
                //是否采用模型验证
                if ($this->modelValidate) {
                    $name = str_replace("\\model\\", "\\validate\\", get_class($this->model));
                    $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.add' : $name) : $this->modelValidate;
                    $this->model->validateFailException()->validate($validate);
                }
                $result = $this->model->allowField(true)->save($params);
                Db::commit();
            } catch (ValidateException|PDOException|Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            if ($result === false) {
                $this->error(__('No rows were inserted'));
            }
            $this->success();
        }
     /**
         * 编辑[改造]
         *
         * @param $ids
         * @return string
         * @throws DbException
         * @throws \think\Exception
         */
        public function edit($ids = null)
        {
            $row = $this->model->get($ids);
            if (!$row) {
                $this->error(__('No Results were found'));
            }
            $adminIds = $this->getDataLimitAdminIds();
            if (is_array($adminIds) && !in_array($row[$this->dataLimitField], $adminIds)) {
                $this->error(__('You have no permission'));
            }
            if (false === $this->request->isPost()) {
                $this->assign('row', $row); //兼容旧组件
                $this->assignconfig('row', $row);
                return $this->view->fetch();
            }
            $params = $this->conversion2str(json_decode($this->request->post('data'),true));
            if (empty($params)) {
                $this->error(__('Parameter %s can not be empty', ''));
            }
            $params = $this->preExcludeFields($params);
            $result = false;
            Db::startTrans();
            try {
                //是否采用模型验证
                if ($this->modelValidate) {
                    $name = str_replace("\\model\\", "\\validate\\", get_class($this->model));
                    $validate = is_bool($this->modelValidate) ? ($this->modelSceneValidate ? $name . '.edit' : $name) : $this->modelValidate;
                    $row->validateFailException()->validate($validate);
                }
                $result = $row->allowField(true)->save($params);
                Db::commit();
            } catch (ValidateException|PDOException|Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            if (false === $result) {
                $this->error(__('No rows were updated'));
            }
            $this->success();
        }
         /**
         * 数组转化为字符串[改造]
         *
         * @param $data
         * @return array
         * @throws DbException
         * @throws \think\Exception
         */
        function conversion2str($data){
        $json_fields=[];
               if (!$data) {
                        $this->error(__('No Results were found'));
                    }
                    foreach($data as $key=>&$items){
                    if(is_array($items)){
                       if(in_array($key,$json_fields)){
                        $items=json_encode($items);
                      }else{
                        $items=implode(',',$items);
                      }

                                          }
                    }
                    return $data;

        }
           /**
             * 读取省市区数据,包含子数据，全部读取
             */
        function area_select()
            {
                $ids = $this->request->get();
                $area = cache('area-cascader');
                $area =Vuearea::cache(true)->with('children.children')->where('level', 1)->order('id asc')->select();

                if($this->request->isAjax()) {
                    $this->success('省市区列表', null, $area);
                }
                $this->assignconfig('areaData', $area);
                return $this->view->fetch();
            }



}
